package com.zygh.policeasset.mapper;

import com.zygh.policeasset.pojo.AssetTransfer;
import java.util.List;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.type.JdbcType;

@Mapper
/* loaded from: police-asset-2.0-0.0.1-SNAPSHOT.jar:BOOT-INF/classes/com/zygh/policeasset/mapper/AssetTransferMapper.class */
public interface AssetTransferMapper {
    @Insert({"insert into asset_transfer (asset_id, asset_type,address,transfer_remark,transfer_status,transfer_dotime) ", "values (#{assetId,jdbcType=INTEGER}, #{assetType,jdbcType=INTEGER}, #{address,jdbcType=VARCHAR},#{transferRemark,jdbcType=VARCHAR},#{transferStatus,jdbcType=INTEGER},#{transferDotime,jdbcType=INTEGER}) "})
    int add(@Param("assetId") Integer num, @Param("assetType") String str, @Param("address") String str2, @Param("transferRemark") String str3, @Param("transferStatus") Integer num2, @Param("transferDotime") String str4);

    @Delete({"delete from asset_transfer where  asset_id = #{assetId} and asset_type = #{assetType} and transfer_status = #{transferStatus}"})
    int delete(@Param("assetId") Integer num, @Param("assetType") String str, @Param("transferStatus") Integer num2);

    @Select({"select * from asset_transfer where asset_id=#{assetId} and asset_type=#{assetType} "})
    @Results(id = "AssetTransferMap", value = {@Result(column = "asset_id", property = "assetId", jdbcType = JdbcType.INTEGER, id = true), @Result(column = "asset_type", property = "assetType", jdbcType = JdbcType.VARCHAR), @Result(column = "address", property = "address", jdbcType = JdbcType.VARCHAR), @Result(column = "transfer_remark", property = "transferRemark", jdbcType = JdbcType.VARCHAR), @Result(column = "transfer_status", property = "transferStatus", jdbcType = JdbcType.VARCHAR), @Result(column = "transfer_dotime", property = "transferDotime", jdbcType = JdbcType.VARCHAR)})
    List<AssetTransfer> findByIdAndType(@Param("assetId") Integer num, @Param("assetType") String str);
}